Navigation
© 2020 DaniWeb® LLC

Replacing variable name in excel

Member Avatar

Hi all,
Before I begin this question, and before you tell me we dont do homework, I would like to state that I have read a few articles, I have tried a couple of functions (=REPLACE, =SUBSTITUTE) but i'm not able to get the reuslts require, I'm new to Excel
Question: Useappropriate text functions to shorten the variable names to something like Arizona Females Young, Arizona Females Old, and Arizona Females All, also is there a way to do it automatically for all variables in 1 function. The screenshot is attached.
It is kind of urgent (I understand people help within their own time).
Thanks in advance.

excel.png

Member Avatar

i hope this explains.

Capture.PNG 18.49 KB
commented: I'm sorry, I am trying hard to understand but maybe I'm not getting it, I'll manually edit and show you what i want +0
Member Avatar

so thats when u can use the formula =RIGHT(A4, LEN(A4)-2) this will remove the fight 2 letters

commented: Please see the screenshot below +0
Member Avatar

Please see this
excel2.png

Member Avatar

and if u use =LEFT(A4, LEN(A4)-9) this will remove the last 9 words hope that explains

commented: Maybe can you show me an example of the function with the screenshot above? +0
Member Avatar

use replace the old text,starting number, number character, text u want to change .

Capture.PNG 8.23 KB
commented: the reason i am not opting for that option is because i have so many states +0
Member Avatar

u can use abbreviation of the states or u can type = replace then scroll down to make sure everything is marked then replace with what u want to replace with

Member Avatar

I got the answer thanks for the help

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!